
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Updates a record in the Article table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Article_Update
(

	@Id int   ,

	@LocalId nvarchar (20)  ,

	@Title nvarchar (200)  ,

	@Alias varchar (200)  ,

	@Summary nvarchar (500)  ,

	@Description ntext   ,

	@ArticleType varchar (20)  ,

	@Thumbnail varchar (200)  ,

	@IsPublished bit   ,

	@OrderIndex int   ,

	@IsAllowDelete bit   ,

	@PublishedDate datetime   ,

	@CreatedDate datetime   ,

	@UpdatedDate datetime   ,

	@CreatedUser varchar (50)  ,

	@UpdatedUser varchar (50)  
)
AS


				
				
				-- Modify the updatable columns
				UPDATE
					[dbo].[Article]
				SET
					[LocalId] = @LocalId
					,[Title] = @Title
					,[Alias] = @Alias
					,[Summary] = @Summary
					,[Description] = @Description
					,[ArticleType] = @ArticleType
					,[Thumbnail] = @Thumbnail
					,[IsPublished] = @IsPublished
					,[OrderIndex] = @OrderIndex
					,[IsAllowDelete] = @IsAllowDelete
					,[PublishedDate] = @PublishedDate
					,[CreatedDate] = @CreatedDate
					,[UpdatedDate] = @UpdatedDate
					,[CreatedUser] = @CreatedUser
					,[UpdatedUser] = @UpdatedUser
				WHERE
[Id] = @Id 
				
			

GO
